package cn.tedu.property_management_system.mapper;

import cn.tedu.property_management_system.entity.Meter;
import cn.tedu.property_management_system.entity.VO.MeterVO;
import cn.tedu.property_management_system.entity.dto.MeterSO;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.time.LocalDateTime;
import java.util.List;

@Repository
public interface MeterMapper {

    int insert(Meter meter);

    int delete(Long id);

    int update(Meter meter);

    List<MeterSO> getByHouseType(@Param("houseNumber") String houseNumber, @Param("expenseType") String expenseType);

    Meter getByTime(@Param("houseNumber") String houseNumber,@Param("meterReadingTime") LocalDateTime meterReadingTime);

    Meter getByHouseNumber(String houseNumber);

    List<MeterSO> select();

    List<String> getHouse();




}
